Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 569338 |
| Missing cells | 2936921 |
| Missing cells (%) | 16.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 134.7 MiB |
| Average record size in memory | 248.0 B |
Variable types
| Numeric | 20 |
|---|---|
| DateTime | 1 |
| Categorical | 4 |
| Text | 6 |
CANCELLED is highly imbalanced (90.4%) | Imbalance |
DIVERTED is highly imbalanced (97.5%) | Imbalance |
DEP_TIME has 6617 (1.2%) missing values | Missing |
DEP_DELAY has 6618 (1.2%) missing values | Missing |
TAXI_OUT has 7018 (1.2%) missing values | Missing |
TAXI_IN has 7146 (1.3%) missing values | Missing |
ARR_TIME has 7145 (1.3%) missing values | Missing |
ARR_DELAY has 8451 (1.5%) missing values | Missing |
CANCELLATION_CODE has 562280 (98.8%) missing values | Missing |
AIR_TIME has 8451 (1.5%) missing values | Missing |
CARRIER_DELAY has 464639 (81.6%) missing values | Missing |
WEATHER_DELAY has 464639 (81.6%) missing values | Missing |
NAS_DELAY has 464639 (81.6%) missing values | Missing |
SECURITY_DELAY has 464639 (81.6%) missing values | Missing |
LATE_AIRCRAFT_DELAY has 464639 (81.6%) missing values | Missing |
SECURITY_DELAY is highly skewed (γ1 = 89.29427867) | Skewed |
DEP_DELAY has 25841 (4.5%) zeros | Zeros |
ARR_DELAY has 10503 (1.8%) zeros | Zeros |
CARRIER_DELAY has 48222 (8.5%) zeros | Zeros |
WEATHER_DELAY has 99278 (17.4%) zeros | Zeros |
NAS_DELAY has 54825 (9.6%) zeros | Zeros |
SECURITY_DELAY has 104179 (18.3%) zeros | Zeros |
LATE_AIRCRAFT_DELAY has 52932 (9.3%) zeros | Zeros |
Reproduction
| Analysis started | 2024-03-30 05:53:18.293431 |
|---|---|
| Analysis finished | 2024-03-30 05:56:06.553725 |
| Duration | 2 minutes and 48.26 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
DAY_OF_WEEK
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.0660434 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.9729996 |
|---|---|
| Coefficient of variation (CV) | 0.4852382 |
| Kurtosis | -1.2055722 |
| Mean | 4.0660434 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.096568792 |
| Sum | 2314953 |
| Variance | 3.8927273 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 5 | 100284 | |
| 6 | 84214 | |
| 4 | 80529 | |
| 1 | 80423 | |
| 7 | 76803 | |
| 3 | 73919 | |
| 2 | 73166 |
| Value | Count | Frequency (%) |
| 1 | 80423 | |
| 2 | 73166 | |
| 3 | 73919 | |
| 4 | 80529 | |
| 5 | 100284 | |
| 6 | 84214 | |
| 7 | 76803 |
| Value | Count | Frequency (%) |
| 7 | 76803 | |
| 6 | 84214 | |
| 5 | 100284 | |
| 4 | 80529 | |
| 3 | 73919 | |
| 2 | 73166 | |
| 1 | 80423 |
FL_DATE
Date
| Distinct | 30 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| Minimum | 2023-09-01 00:00:00 |
|---|---|
| Maximum | 2023-09-30 00:00:00 |
Histogram with fixed size bins (bins=30)
OP_UNIQUE_CARRIER
Categorical
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| WN | |
|---|---|
| DL | |
| AA | |
| UA | |
| OO | |
| Other values (10) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1138676 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 9E |
|---|---|
| 2nd row | 9E |
| 3rd row | 9E |
| 4th row | 9E |
| 5th row | 9E |
Common Values
| Value | Count | Frequency (%) |
| WN | 117870 | |
| DL | 81701 | |
| AA | 76972 | |
| UA | 62591 | |
| OO | 59245 | |
| YX | 24839 | 4.4% |
| AS | 21426 | 3.8% |
| B6 | 21412 | 3.8% |
| NK | 21036 | 3.7% |
| MQ | 18789 | 3.3% |
| Other values (5) | 63457 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| wn | 117870 | |
| dl | 81701 | |
| aa | 76972 | |
| ua | 62591 | |
| oo | 59245 | |
| yx | 24839 | 4.4% |
| as | 21426 | 3.8% |
| b6 | 21412 | 3.8% |
| nk | 21036 | 3.7% |
| mq | 18789 | 3.3% |
| Other values (5) | 63457 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 244679 | |
| N | 138906 | |
| O | 134665 | |
| W | 117870 | |
| D | 81701 | 7.2% |
| L | 81701 | 7.2% |
| U | 62591 | 5.5% |
| 9 | 33672 | 3.0% |
| Y | 24839 | 2.2% |
| X | 24839 | 2.2% |
| Other values (11) | 193213 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1138676 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 244679 | |
| N | 138906 | |
| O | 134665 | |
| W | 117870 | |
| D | 81701 | 7.2% |
| L | 81701 | 7.2% |
| U | 62591 | 5.5% |
| 9 | 33672 | 3.0% |
| Y | 24839 | 2.2% |
| X | 24839 | 2.2% |
| Other values (11) | 193213 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1138676 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 244679 | |
| N | 138906 | |
| O | 134665 | |
| W | 117870 | |
| D | 81701 | 7.2% |
| L | 81701 | 7.2% |
| U | 62591 | 5.5% |
| 9 | 33672 | 3.0% |
| Y | 24839 | 2.2% |
| X | 24839 | 2.2% |
| Other values (11) | 193213 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1138676 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 244679 | |
| N | 138906 | |
| O | 134665 | |
| W | 117870 | |
| D | 81701 | 7.2% |
| L | 81701 | 7.2% |
| U | 62591 | 5.5% |
| 9 | 33672 | 3.0% |
| Y | 24839 | 2.2% |
| X | 24839 | 2.2% |
| Other values (11) | 193213 |
OP_CARRIER_FL_NUM
Real number (ℝ)
| Distinct | 5936 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2353.8195 |
| Minimum | 1 |
|---|---|
| Maximum | 8819 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 294.85 |
| Q1 | 1081 |
| median | 2117 |
| Q3 | 3437 |
| 95-th percentile | 5386 |
| Maximum | 8819 |
| Range | 8818 |
| Interquartile range (IQR) | 2356 |
Descriptive statistics
| Standard deviation | 1575.1363 |
|---|---|
| Coefficient of variation (CV) | 0.66918311 |
| Kurtosis | -0.66830596 |
| Mean | 2353.8195 |
| Median Absolute Deviation (MAD) | 1140 |
| Skewness | 0.55299996 |
| Sum | 1.3401189 × 109 |
| Variance | 2481054.3 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1167 | 294 | 0.1% |
| 321 | 284 | < 0.1% |
| 555 | 283 | < 0.1% |
| 398 | 277 | < 0.1% |
| 540 | 275 | < 0.1% |
| 656 | 275 | < 0.1% |
| 1168 | 274 | < 0.1% |
| 383 | 270 | < 0.1% |
| 2080 | 269 | < 0.1% |
| 1008 | 267 | < 0.1% |
| Other values (5926) | 566570 |
| Value | Count | Frequency (%) |
| 1 | 208 | |
| 2 | 173 | |
| 3 | 93 | |
| 4 | 161 | |
| 5 | 90 | |
| 6 | 86 | < 0.1% |
| 7 | 158 | |
| 8 | 75 | < 0.1% |
| 9 | 160 | |
| 10 | 217 |
| Value | Count | Frequency (%) |
| 8819 | 1 | < 0.1% |
| 8801 | 1 | < 0.1% |
| 8800 | 3 | |
| 8792 | 2 | |
| 8791 | 1 | < 0.1% |
| 8790 | 2 | |
| 8789 | 1 | < 0.1% |
| 8788 | 1 | < 0.1% |
| 8787 | 2 | |
| 8786 | 2 |
ORIGIN_AIRPORT_ID
Real number (ℝ)
| Distinct | 340 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12636.878 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14027 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2735 |
Descriptive statistics
| Standard deviation | 1533.8691 |
|---|---|
| Coefficient of variation (CV) | 0.12138038 |
| Kurtosis | -1.3056074 |
| Mean | 12636.878 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.11709455 |
| Sum | 7.194655 × 109 |
| Variance | 2352754.3 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10397 | 28344 | 5.0% |
| 11292 | 24738 | 4.3% |
| 11298 | 24533 | 4.3% |
| 13930 | 22384 | 3.9% |
| 11057 | 16175 | 2.8% |
| 12892 | 16152 | 2.8% |
| 12889 | 16110 | 2.8% |
| 14747 | 15041 | 2.6% |
| 14107 | 14285 | 2.5% |
| 12953 | 13372 | 2.3% |
| Other values (330) | 378204 |
| Value | Count | Frequency (%) |
| 10135 | 376 | 0.1% |
| 10136 | 118 | < 0.1% |
| 10140 | 2131 | |
| 10141 | 60 | < 0.1% |
| 10146 | 60 | < 0.1% |
| 10154 | 231 | < 0.1% |
| 10155 | 84 | < 0.1% |
| 10157 | 142 | < 0.1% |
| 10158 | 249 | < 0.1% |
| 10165 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 150 | < 0.1% |
| 16218 | 148 | < 0.1% |
| 15991 | 60 | < 0.1% |
| 15919 | 1017 | |
| 15897 | 60 | < 0.1% |
| 15841 | 60 | < 0.1% |
| 15624 | 741 | |
| 15607 | 60 | < 0.1% |
| 15582 | 51 | < 0.1% |
| 15569 | 51 | < 0.1% |
ORIGIN
Text
| Distinct | 340 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1708014 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | BNA |
|---|---|
| 2nd row | LGA |
| 3rd row | RIC |
| 4th row | CLT |
| 5th row | JFK |
| Value | Count | Frequency (%) |
| atl | 28344 | 5.0% |
| den | 24738 | 4.3% |
| dfw | 24533 | 4.3% |
| ord | 22384 | 3.9% |
| clt | 16175 | 2.8% |
| lax | 16152 | 2.8% |
| las | 16110 | 2.8% |
| sea | 15041 | 2.6% |
| phx | 14285 | 2.5% |
| lga | 13372 | 2.3% |
| Other values (330) | 378204 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 195455 | 11.4% |
| L | 157746 | 9.2% |
| S | 146077 | 8.6% |
| D | 137148 | 8.0% |
| T | 90340 | 5.3% |
| O | 87035 | 5.1% |
| C | 85620 | 5.0% |
| M | 74652 | 4.4% |
| F | 71066 | 4.2% |
| E | 67731 | 4.0% |
| Other values (16) | 595144 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1708014 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 195455 | 11.4% |
| L | 157746 | 9.2% |
| S | 146077 | 8.6% |
| D | 137148 | 8.0% |
| T | 90340 | 5.3% |
| O | 87035 | 5.1% |
| C | 85620 | 5.0% |
| M | 74652 | 4.4% |
| F | 71066 | 4.2% |
| E | 67731 | 4.0% |
| Other values (16) | 595144 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1708014 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 195455 | 11.4% |
| L | 157746 | 9.2% |
| S | 146077 | 8.6% |
| D | 137148 | 8.0% |
| T | 90340 | 5.3% |
| O | 87035 | 5.1% |
| C | 85620 | 5.0% |
| M | 74652 | 4.4% |
| F | 71066 | 4.2% |
| E | 67731 | 4.0% |
| Other values (16) | 595144 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1708014 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 195455 | 11.4% |
| L | 157746 | 9.2% |
| S | 146077 | 8.6% |
| D | 137148 | 8.0% |
| T | 90340 | 5.3% |
| O | 87035 | 5.1% |
| C | 85620 | 5.0% |
| M | 74652 | 4.4% |
| F | 71066 | 4.2% |
| E | 67731 | 4.0% |
| Other values (16) | 595144 |
ORIGIN_CITY_NAME
Text
| Distinct | 334 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.039801 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7424054 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Nashville, TN |
|---|---|
| 2nd row | New York, NY |
| 3rd row | Richmond, VA |
| 4th row | Charlotte, NC |
| 5th row | New York, NY |
| Value | Count | Frequency (%) |
| ca | 61847 | 4.7% |
| tx | 60810 | 4.6% |
| fl | 43758 | 3.3% |
| ny | 30676 | 2.3% |
| il | 30379 | 2.3% |
| ga | 30297 | 2.3% |
| san | 29589 | 2.2% |
| chicago | 29493 | 2.2% |
| atlanta | 28344 | 2.1% |
| new | 27749 | 2.1% |
| Other values (407) | 950846 |
Most occurring characters
| Value | Count | Frequency (%) |
| 754450 | 10.2% | |
| , | 569338 | 7.7% |
| a | 565926 | 7.6% |
| o | 409299 | 5.5% |
| e | 392692 | 5.3% |
| n | 363301 | 4.9% |
| t | 357737 | 4.8% |
| l | 330201 | 4.4% |
| i | 284039 | 3.8% |
| r | 265682 | 3.6% |
| Other values (47) | 3131389 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7424054 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 754450 | 10.2% | |
| , | 569338 | 7.7% |
| a | 565926 | 7.6% |
| o | 409299 | 5.5% |
| e | 392692 | 5.3% |
| n | 363301 | 4.9% |
| t | 357737 | 4.8% |
| l | 330201 | 4.4% |
| i | 284039 | 3.8% |
| r | 265682 | 3.6% |
| Other values (47) | 3131389 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7424054 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 754450 | 10.2% | |
| , | 569338 | 7.7% |
| a | 565926 | 7.6% |
| o | 409299 | 5.5% |
| e | 392692 | 5.3% |
| n | 363301 | 4.9% |
| t | 357737 | 4.8% |
| l | 330201 | 4.4% |
| i | 284039 | 3.8% |
| r | 265682 | 3.6% |
| Other values (47) | 3131389 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7424054 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 754450 | 10.2% | |
| , | 569338 | 7.7% |
| a | 565926 | 7.6% |
| o | 409299 | 5.5% |
| e | 392692 | 5.3% |
| n | 363301 | 4.9% |
| t | 357737 | 4.8% |
| l | 330201 | 4.4% |
| i | 284039 | 3.8% |
| r | 265682 | 3.6% |
| Other values (47) | 3131389 |
ORIGIN_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.1698288 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4651394 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Tennessee |
|---|---|
| 2nd row | New York |
| 3rd row | Virginia |
| 4th row | North Carolina |
| 5th row | New York |
| Value | Count | Frequency (%) |
| california | 61847 | 9.5% |
| texas | 60810 | 9.3% |
| new | 45391 | 7.0% |
| florida | 43758 | 6.7% |
| york | 30676 | 4.7% |
| illinois | 30379 | 4.7% |
| georgia | 30297 | 4.6% |
| carolina | 29513 | 4.5% |
| colorado | 27332 | 4.2% |
| north | 25651 | 3.9% |
| Other values (51) | 266052 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 624851 | |
| i | 520822 | 11.2% |
| o | 443414 | 9.5% |
| n | 351144 | 7.5% |
| r | 330787 | 7.1% |
| e | 288209 | 6.2% |
| s | 270558 | 5.8% |
| l | 254909 | 5.5% |
| C | 120424 | 2.6% |
| t | 111963 | 2.4% |
| Other values (37) | 1334313 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4651394 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 624851 | |
| i | 520822 | 11.2% |
| o | 443414 | 9.5% |
| n | 351144 | 7.5% |
| r | 330787 | 7.1% |
| e | 288209 | 6.2% |
| s | 270558 | 5.8% |
| l | 254909 | 5.5% |
| C | 120424 | 2.6% |
| t | 111963 | 2.4% |
| Other values (37) | 1334313 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4651394 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 624851 | |
| i | 520822 | 11.2% |
| o | 443414 | 9.5% |
| n | 351144 | 7.5% |
| r | 330787 | 7.1% |
| e | 288209 | 6.2% |
| s | 270558 | 5.8% |
| l | 254909 | 5.5% |
| C | 120424 | 2.6% |
| t | 111963 | 2.4% |
| Other values (37) | 1334313 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4651394 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 624851 | |
| i | 520822 | 11.2% |
| o | 443414 | 9.5% |
| n | 351144 | 7.5% |
| r | 330787 | 7.1% |
| e | 288209 | 6.2% |
| s | 270558 | 5.8% |
| l | 254909 | 5.5% |
| C | 120424 | 2.6% |
| t | 111963 | 2.4% |
| Other values (37) | 1334313 |
ORIGIN_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.990457 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 34 |
| median | 51 |
| Q3 | 82 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.783593 |
|---|---|
| Coefficient of variation (CV) | 0.48705893 |
| Kurtosis | -1.3208812 |
| Mean | 54.990457 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | -0.050075234 |
| Sum | 31308157 |
| Variance | 717.36086 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 91 | 61847 | 10.9% |
| 74 | 60810 | 10.7% |
| 33 | 43758 | 7.7% |
| 22 | 30676 | 5.4% |
| 41 | 30379 | 5.3% |
| 34 | 30297 | 5.3% |
| 82 | 27332 | 4.8% |
| 36 | 24293 | 4.3% |
| 38 | 19832 | 3.5% |
| 85 | 17793 | 3.1% |
| Other values (42) | 222321 |
| Value | Count | Frequency (%) |
| 1 | 3191 | 0.6% |
| 2 | 10538 | |
| 3 | 2474 | 0.4% |
| 4 | 257 | < 0.1% |
| 5 | 100 | < 0.1% |
| 11 | 1732 | 0.3% |
| 12 | 1728 | 0.3% |
| 13 | 12228 | |
| 14 | 544 | 0.1% |
| 15 | 1235 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 17416 | 3.1% |
| 92 | 6461 | 1.1% |
| 91 | 61847 | |
| 88 | 839 | 0.1% |
| 87 | 9707 | 1.7% |
| 86 | 2364 | 0.4% |
| 85 | 17793 | 3.1% |
| 84 | 2248 | 0.4% |
| 83 | 2365 | 0.4% |
| 82 | 27332 |
DEST_AIRPORT_ID
Real number (ℝ)
| Distinct | 340 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12636.993 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14027 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2735 |
Descriptive statistics
| Standard deviation | 1533.9335 |
|---|---|
| Coefficient of variation (CV) | 0.12138438 |
| Kurtosis | -1.3057584 |
| Mean | 12636.993 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.11690032 |
| Sum | 7.1947203 × 109 |
| Variance | 2352952.1 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10397 | 28359 | 5.0% |
| 11292 | 24727 | 4.3% |
| 11298 | 24531 | 4.3% |
| 13930 | 22368 | 3.9% |
| 11057 | 16168 | 2.8% |
| 12892 | 16152 | 2.8% |
| 12889 | 16130 | 2.8% |
| 14747 | 15057 | 2.6% |
| 14107 | 14281 | 2.5% |
| 12953 | 13371 | 2.3% |
| Other values (330) | 378194 |
| Value | Count | Frequency (%) |
| 10135 | 377 | 0.1% |
| 10136 | 118 | < 0.1% |
| 10140 | 2136 | |
| 10141 | 60 | < 0.1% |
| 10146 | 60 | < 0.1% |
| 10154 | 231 | < 0.1% |
| 10155 | 84 | < 0.1% |
| 10157 | 142 | < 0.1% |
| 10158 | 249 | < 0.1% |
| 10165 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 150 | < 0.1% |
| 16218 | 147 | < 0.1% |
| 15991 | 60 | < 0.1% |
| 15919 | 1016 | |
| 15897 | 60 | < 0.1% |
| 15841 | 60 | < 0.1% |
| 15624 | 741 | |
| 15607 | 60 | < 0.1% |
| 15582 | 51 | < 0.1% |
| 15569 | 51 | < 0.1% |
DEST
Text
| Distinct | 340 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1708014 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | LGA |
|---|---|
| 2nd row | BNA |
| 3rd row | MSP |
| 4th row | JFK |
| 5th row | CLT |
| Value | Count | Frequency (%) |
| atl | 28359 | 5.0% |
| den | 24727 | 4.3% |
| dfw | 24531 | 4.3% |
| ord | 22368 | 3.9% |
| clt | 16168 | 2.8% |
| lax | 16152 | 2.8% |
| las | 16130 | 2.8% |
| sea | 15057 | 2.6% |
| phx | 14281 | 2.5% |
| lga | 13371 | 2.3% |
| Other values (330) | 378194 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 195473 | 11.4% |
| L | 157775 | 9.2% |
| S | 146122 | 8.6% |
| D | 137121 | 8.0% |
| T | 90352 | 5.3% |
| O | 87039 | 5.1% |
| C | 85591 | 5.0% |
| M | 74640 | 4.4% |
| F | 71087 | 4.2% |
| E | 67732 | 4.0% |
| Other values (16) | 595082 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1708014 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 195473 | 11.4% |
| L | 157775 | 9.2% |
| S | 146122 | 8.6% |
| D | 137121 | 8.0% |
| T | 90352 | 5.3% |
| O | 87039 | 5.1% |
| C | 85591 | 5.0% |
| M | 74640 | 4.4% |
| F | 71087 | 4.2% |
| E | 67732 | 4.0% |
| Other values (16) | 595082 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1708014 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 195473 | 11.4% |
| L | 157775 | 9.2% |
| S | 146122 | 8.6% |
| D | 137121 | 8.0% |
| T | 90352 | 5.3% |
| O | 87039 | 5.1% |
| C | 85591 | 5.0% |
| M | 74640 | 4.4% |
| F | 71087 | 4.2% |
| E | 67732 | 4.0% |
| Other values (16) | 595082 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1708014 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 195473 | 11.4% |
| L | 157775 | 9.2% |
| S | 146122 | 8.6% |
| D | 137121 | 8.0% |
| T | 90352 | 5.3% |
| O | 87039 | 5.1% |
| C | 85591 | 5.0% |
| M | 74640 | 4.4% |
| F | 71087 | 4.2% |
| E | 67732 | 4.0% |
| Other values (16) | 595082 |
DEST_CITY_NAME
Text
| Distinct | 334 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.040436 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7424416 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | New York, NY |
|---|---|
| 2nd row | Nashville, TN |
| 3rd row | Minneapolis, MN |
| 4th row | New York, NY |
| 5th row | Charlotte, NC |
| Value | Count | Frequency (%) |
| ca | 61865 | 4.7% |
| tx | 60790 | 4.6% |
| fl | 43743 | 3.3% |
| ny | 30681 | 2.3% |
| il | 30356 | 2.3% |
| ga | 30312 | 2.3% |
| san | 29597 | 2.2% |
| chicago | 29471 | 2.2% |
| atlanta | 28359 | 2.1% |
| new | 27751 | 2.1% |
| Other values (407) | 950910 |
Most occurring characters
| Value | Count | Frequency (%) |
| 754497 | 10.2% | |
| , | 569338 | 7.7% |
| a | 565980 | 7.6% |
| o | 409292 | 5.5% |
| e | 392742 | 5.3% |
| n | 363304 | 4.9% |
| t | 357778 | 4.8% |
| l | 330251 | 4.4% |
| i | 284036 | 3.8% |
| r | 265684 | 3.6% |
| Other values (47) | 3131514 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7424416 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 754497 | 10.2% | |
| , | 569338 | 7.7% |
| a | 565980 | 7.6% |
| o | 409292 | 5.5% |
| e | 392742 | 5.3% |
| n | 363304 | 4.9% |
| t | 357778 | 4.8% |
| l | 330251 | 4.4% |
| i | 284036 | 3.8% |
| r | 265684 | 3.6% |
| Other values (47) | 3131514 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7424416 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 754497 | 10.2% | |
| , | 569338 | 7.7% |
| a | 565980 | 7.6% |
| o | 409292 | 5.5% |
| e | 392742 | 5.3% |
| n | 363304 | 4.9% |
| t | 357778 | 4.8% |
| l | 330251 | 4.4% |
| i | 284036 | 3.8% |
| r | 265684 | 3.6% |
| Other values (47) | 3131514 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7424416 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 754497 | 10.2% | |
| , | 569338 | 7.7% |
| a | 565980 | 7.6% |
| o | 409292 | 5.5% |
| e | 392742 | 5.3% |
| n | 363304 | 4.9% |
| t | 357778 | 4.8% |
| l | 330251 | 4.4% |
| i | 284036 | 3.8% |
| r | 265684 | 3.6% |
| Other values (47) | 3131514 |
DEST_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.169755 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4651352 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York |
|---|---|
| 2nd row | Tennessee |
| 3rd row | Minnesota |
| 4th row | New York |
| 5th row | North Carolina |
| Value | Count | Frequency (%) |
| california | 61865 | 9.5% |
| texas | 60790 | 9.3% |
| new | 45396 | 7.0% |
| florida | 43743 | 6.7% |
| york | 30681 | 4.7% |
| illinois | 30356 | 4.7% |
| georgia | 30312 | 4.7% |
| carolina | 29506 | 4.5% |
| colorado | 27317 | 4.2% |
| north | 25650 | 3.9% |
| Other values (51) | 266078 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 624907 | |
| i | 520819 | 11.2% |
| o | 443382 | 9.5% |
| n | 351161 | 7.5% |
| r | 330775 | 7.1% |
| e | 288213 | 6.2% |
| s | 270525 | 5.8% |
| l | 254839 | 5.5% |
| C | 120421 | 2.6% |
| t | 111964 | 2.4% |
| Other values (37) | 1334346 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4651352 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 624907 | |
| i | 520819 | 11.2% |
| o | 443382 | 9.5% |
| n | 351161 | 7.5% |
| r | 330775 | 7.1% |
| e | 288213 | 6.2% |
| s | 270525 | 5.8% |
| l | 254839 | 5.5% |
| C | 120421 | 2.6% |
| t | 111964 | 2.4% |
| Other values (37) | 1334346 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4651352 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 624907 | |
| i | 520819 | 11.2% |
| o | 443382 | 9.5% |
| n | 351161 | 7.5% |
| r | 330775 | 7.1% |
| e | 288213 | 6.2% |
| s | 270525 | 5.8% |
| l | 254839 | 5.5% |
| C | 120421 | 2.6% |
| t | 111964 | 2.4% |
| Other values (37) | 1334346 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4651352 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 624907 | |
| i | 520819 | 11.2% |
| o | 443382 | 9.5% |
| n | 351161 | 7.5% |
| r | 330775 | 7.1% |
| e | 288213 | 6.2% |
| s | 270525 | 5.8% |
| l | 254839 | 5.5% |
| C | 120421 | 2.6% |
| t | 111964 | 2.4% |
| Other values (37) | 1334346 |
DEST_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.996299 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 34 |
| median | 51 |
| Q3 | 82 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.783854 |
|---|---|
| Coefficient of variation (CV) | 0.48701193 |
| Kurtosis | -1.321044 |
| Mean | 54.996299 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | -0.050254634 |
| Sum | 31311483 |
| Variance | 717.37484 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 91 | 61865 | 10.9% |
| 74 | 60790 | 10.7% |
| 33 | 43743 | 7.7% |
| 22 | 30681 | 5.4% |
| 41 | 30356 | 5.3% |
| 34 | 30312 | 5.3% |
| 82 | 27317 | 4.8% |
| 36 | 24292 | 4.3% |
| 38 | 19828 | 3.5% |
| 85 | 17815 | 3.1% |
| Other values (42) | 222339 |
| Value | Count | Frequency (%) |
| 1 | 3184 | 0.6% |
| 2 | 10540 | |
| 3 | 2462 | 0.4% |
| 4 | 257 | < 0.1% |
| 5 | 100 | < 0.1% |
| 11 | 1733 | 0.3% |
| 12 | 1731 | 0.3% |
| 13 | 12225 | |
| 14 | 544 | 0.1% |
| 15 | 1236 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 17435 | 3.1% |
| 92 | 6469 | 1.1% |
| 91 | 61865 | |
| 88 | 835 | 0.1% |
| 87 | 9707 | 1.7% |
| 86 | 2369 | 0.4% |
| 85 | 17815 | 3.1% |
| 84 | 2246 | 0.4% |
| 83 | 2369 | 0.4% |
| 82 | 27317 |
CRS_DEP_TIME
Real number (ℝ)
| Distinct | 1210 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1327.5619 |
| Minimum | 4 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 605 |
| Q1 | 910 |
| median | 1319 |
| Q3 | 1734 |
| 95-th percentile | 2120 |
| Maximum | 2359 |
| Range | 2355 |
| Interquartile range (IQR) | 824 |
Descriptive statistics
| Standard deviation | 487.11931 |
|---|---|
| Coefficient of variation (CV) | 0.36692777 |
| Kurtosis | -1.0624147 |
| Mean | 1327.5619 |
| Median Absolute Deviation (MAD) | 411 |
| Skewness | 0.096408495 |
| Sum | 7.5583142 × 108 |
| Variance | 237285.23 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 600 | 11487 | 2.0% |
| 700 | 8559 | 1.5% |
| 800 | 5275 | 0.9% |
| 630 | 3617 | 0.6% |
| 900 | 3594 | 0.6% |
| 830 | 3489 | 0.6% |
| 1000 | 3471 | 0.6% |
| 1100 | 3183 | 0.6% |
| 730 | 3088 | 0.5% |
| 710 | 2936 | 0.5% |
| Other values (1200) | 520639 |
| Value | Count | Frequency (%) |
| 4 | 3 | < 0.1% |
| 5 | 26 | < 0.1% |
| 10 | 13 | < 0.1% |
| 15 | 66 | |
| 20 | 2 | < 0.1% |
| 21 | 5 | < 0.1% |
| 22 | 3 | < 0.1% |
| 24 | 9 | < 0.1% |
| 25 | 7 | < 0.1% |
| 28 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2359 | 722 | |
| 2358 | 63 | < 0.1% |
| 2357 | 83 | < 0.1% |
| 2356 | 31 | < 0.1% |
| 2355 | 277 | < 0.1% |
| 2354 | 61 | < 0.1% |
| 2353 | 7 | < 0.1% |
| 2352 | 90 | < 0.1% |
| 2351 | 8 | < 0.1% |
| 2350 | 112 | < 0.1% |
DEP_TIME
Real number (ℝ)
MISSING
| Distinct | 1413 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 6617 |
| Missing (%) | 1.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1329.0055 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 601 |
| Q1 | 911 |
| median | 1320 |
| Q3 | 1741 |
| 95-th percentile | 2134 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 830 |
Descriptive statistics
| Standard deviation | 501.71604 |
|---|---|
| Coefficient of variation (CV) | 0.3775124 |
| Kurtosis | -0.9925861 |
| Mean | 1329.0055 |
| Median Absolute Deviation (MAD) | 415 |
| Skewness | 0.054983195 |
| Sum | 7.4785928 × 108 |
| Variance | 251718.98 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 555 | 1507 | 0.3% |
| 557 | 1260 | 0.2% |
| 556 | 1233 | 0.2% |
| 558 | 1219 | 0.2% |
| 554 | 1211 | 0.2% |
| 655 | 1184 | 0.2% |
| 559 | 1158 | 0.2% |
| 654 | 1135 | 0.2% |
| 553 | 1115 | 0.2% |
| 656 | 1073 | 0.2% |
| Other values (1403) | 550626 | |
| (Missing) | 6617 | 1.2% |
| Value | Count | Frequency (%) |
| 1 | 79 | |
| 2 | 53 | |
| 3 | 47 | |
| 4 | 50 | |
| 5 | 48 | |
| 6 | 56 | |
| 7 | 42 | |
| 8 | 48 | |
| 9 | 37 | |
| 10 | 40 |
| Value | Count | Frequency (%) |
| 2400 | 40 | < 0.1% |
| 2359 | 75 | |
| 2358 | 83 | |
| 2357 | 84 | |
| 2356 | 90 | |
| 2355 | 116 | |
| 2354 | 109 | |
| 2353 | 115 | |
| 2352 | 139 | |
| 2351 | 120 |
DEP_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 1139 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 6618 |
| Missing (%) | 1.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.880909 |
| Minimum | -42 |
|---|---|
| Maximum | 2360 |
| Zeros | 25841 |
| Zeros (%) | 4.5% |
| Negative | 338647 |
| Negative (%) | 59.5% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | -42 |
|---|---|
| 5-th percentile | -10 |
| Q1 | -6 |
| median | -2 |
| Q3 | 7 |
| 95-th percentile | 73 |
| Maximum | 2360 |
| Range | 2402 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 53.844126 |
|---|---|
| Coefficient of variation (CV) | 4.9484953 |
| Kurtosis | 211.97886 |
| Mean | 10.880909 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 11.323317 |
| Sum | 6122905 |
| Variance | 2899.1899 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -5 | 44214 | 7.8% |
| -4 | 40368 | 7.1% |
| -3 | 38444 | 6.8% |
| -6 | 35833 | 6.3% |
| -2 | 34387 | 6.0% |
| -1 | 30687 | 5.4% |
| -7 | 30681 | 5.4% |
| 0 | 25841 | 4.5% |
| -8 | 24909 | 4.4% |
| -9 | 18767 | 3.3% |
| Other values (1129) | 238589 |
| Value | Count | Frequency (%) |
| -42 | 1 | < 0.1% |
| -38 | 1 | < 0.1% |
| -37 | 1 | < 0.1% |
| -33 | 3 | < 0.1% |
| -32 | 5 | < 0.1% |
| -31 | 2 | < 0.1% |
| -30 | 2 | < 0.1% |
| -29 | 6 | < 0.1% |
| -28 | 15 | |
| -27 | 14 |
| Value | Count | Frequency (%) |
| 2360 | 1 | |
| 2329 | 1 | |
| 2304 | 1 | |
| 2293 | 1 | |
| 2218 | 1 | |
| 2027 | 1 | |
| 1789 | 1 | |
| 1761 | 1 | |
| 1701 | 1 | |
| 1691 | 1 |
TAXI_OUT
Real number (ℝ)
MISSING
| Distinct | 176 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 7018 |
| Missing (%) | 1.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.490032 |
| Minimum | 1 |
|---|---|
| Maximum | 182 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 12 |
| median | 15 |
| Q3 | 20 |
| 95-th percentile | 33 |
| Maximum | 182 |
| Range | 181 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 9.4663944 |
|---|---|
| Coefficient of variation (CV) | 0.5412451 |
| Kurtosis | 30.626669 |
| Mean | 17.490032 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 3.9024438 |
| Sum | 9834995 |
| Variance | 89.612622 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 12 | 46044 | 8.1% |
| 13 | 45664 | 8.0% |
| 14 | 43518 | 7.6% |
| 11 | 42164 | 7.4% |
| 15 | 39184 | 6.9% |
| 16 | 34947 | 6.1% |
| 10 | 33745 | 5.9% |
| 17 | 30455 | 5.3% |
| 18 | 25915 | 4.6% |
| 9 | 23110 | 4.1% |
| Other values (166) | 197574 |
| Value | Count | Frequency (%) |
| 1 | 9 | < 0.1% |
| 2 | 12 | < 0.1% |
| 3 | 56 | < 0.1% |
| 4 | 197 | < 0.1% |
| 5 | 489 | 0.1% |
| 6 | 2158 | 0.4% |
| 7 | 6059 | 1.1% |
| 8 | 12829 | 2.3% |
| 9 | 23110 | |
| 10 | 33745 |
| Value | Count | Frequency (%) |
| 182 | 1 | < 0.1% |
| 180 | 1 | < 0.1% |
| 177 | 1 | < 0.1% |
| 176 | 2 | |
| 175 | 1 | < 0.1% |
| 173 | 2 | |
| 172 | 1 | < 0.1% |
| 170 | 1 | < 0.1% |
| 169 | 4 | |
| 168 | 1 | < 0.1% |
TAXI_IN
Real number (ℝ)
MISSING
| Distinct | 147 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 7146 |
| Missing (%) | 1.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.1845419 |
| Minimum | 1 |
|---|---|
| Maximum | 204 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 6 |
| Q3 | 10 |
| 95-th percentile | 19 |
| Maximum | 204 |
| Range | 203 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 6.4990072 |
|---|---|
| Coefficient of variation (CV) | 0.79405875 |
| Kurtosis | 44.770239 |
| Mean | 8.1845419 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 4.5736456 |
| Sum | 4601284 |
| Variance | 42.237094 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4 | 80866 | |
| 5 | 79036 | |
| 6 | 65830 | |
| 7 | 52712 | |
| 3 | 49271 | |
| 8 | 41657 | |
| 9 | 33506 | 5.9% |
| 10 | 26736 | 4.7% |
| 11 | 21034 | 3.7% |
| 12 | 16648 | 2.9% |
| Other values (137) | 94896 |
| Value | Count | Frequency (%) |
| 1 | 791 | 0.1% |
| 2 | 12273 | 2.2% |
| 3 | 49271 | |
| 4 | 80866 | |
| 5 | 79036 | |
| 6 | 65830 | |
| 7 | 52712 | |
| 8 | 41657 | |
| 9 | 33506 | |
| 10 | 26736 | 4.7% |
| Value | Count | Frequency (%) |
| 204 | 1 | |
| 194 | 1 | |
| 167 | 2 | |
| 166 | 2 | |
| 164 | 1 | |
| 158 | 1 | |
| 156 | 1 | |
| 154 | 1 | |
| 149 | 2 | |
| 146 | 1 |
CRS_ARR_TIME
Real number (ℝ)
| Distinct | 1305 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1491.9401 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 727 |
| Q1 | 1105 |
| median | 1516 |
| Q3 | 1920 |
| 95-th percentile | 2255 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 815 |
Descriptive statistics
| Standard deviation | 512.24471 |
|---|---|
| Coefficient of variation (CV) | 0.34334134 |
| Kurtosis | -0.52391417 |
| Mean | 1491.9401 |
| Median Absolute Deviation (MAD) | 408 |
| Skewness | -0.25743788 |
| Sum | 8.494182 × 108 |
| Variance | 262394.64 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2359 | 3201 | 0.6% |
| 1200 | 1799 | 0.3% |
| 2000 | 1786 | 0.3% |
| 2100 | 1680 | 0.3% |
| 950 | 1637 | 0.3% |
| 1500 | 1618 | 0.3% |
| 1620 | 1614 | 0.3% |
| 1030 | 1611 | 0.3% |
| 2025 | 1609 | 0.3% |
| 1000 | 1603 | 0.3% |
| Other values (1295) | 551180 |
| Value | Count | Frequency (%) |
| 1 | 165 | < 0.1% |
| 2 | 111 | < 0.1% |
| 3 | 62 | < 0.1% |
| 4 | 112 | < 0.1% |
| 5 | 458 | |
| 6 | 92 | < 0.1% |
| 7 | 61 | < 0.1% |
| 8 | 92 | < 0.1% |
| 9 | 76 | < 0.1% |
| 10 | 291 |
| Value | Count | Frequency (%) |
| 2359 | 3201 | |
| 2358 | 1069 | 0.2% |
| 2357 | 640 | 0.1% |
| 2356 | 520 | 0.1% |
| 2355 | 904 | 0.2% |
| 2354 | 351 | 0.1% |
| 2353 | 413 | 0.1% |
| 2352 | 347 | 0.1% |
| 2351 | 282 | < 0.1% |
| 2350 | 582 | 0.1% |
ARR_TIME
Real number (ℝ)
MISSING
| Distinct | 1440 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 7145 |
| Missing (%) | 1.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1463.1941 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 652 |
| Q1 | 1047 |
| median | 1501 |
| Q3 | 1915 |
| 95-th percentile | 2251 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 868 |
Descriptive statistics
| Standard deviation | 536.73604 |
|---|---|
| Coefficient of variation (CV) | 0.36682492 |
| Kurtosis | -0.38786529 |
| Mean | 1463.1941 |
| Median Absolute Deviation (MAD) | 425 |
| Skewness | -0.34605965 |
| Sum | 8.2259745 × 108 |
| Variance | 288085.57 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1628 | 660 | 0.1% |
| 941 | 649 | 0.1% |
| 1635 | 642 | 0.1% |
| 1140 | 642 | 0.1% |
| 1144 | 641 | 0.1% |
| 1638 | 638 | 0.1% |
| 1853 | 632 | 0.1% |
| 1243 | 632 | 0.1% |
| 1227 | 627 | 0.1% |
| 943 | 623 | 0.1% |
| Other values (1430) | 555807 | |
| (Missing) | 7145 | 1.3% |
| Value | Count | Frequency (%) |
| 1 | 378 | |
| 2 | 317 | |
| 3 | 302 | |
| 4 | 308 | |
| 5 | 294 | |
| 6 | 300 | |
| 7 | 269 | |
| 8 | 268 | |
| 9 | 288 | |
| 10 | 262 |
| Value | Count | Frequency (%) |
| 2400 | 296 | |
| 2359 | 340 | |
| 2358 | 373 | |
| 2357 | 328 | |
| 2356 | 355 | |
| 2355 | 353 | |
| 2354 | 352 | |
| 2353 | 387 | |
| 2352 | 376 | |
| 2351 | 405 |
ARR_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 1148 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 8451 |
| Missing (%) | 1.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.3939742 |
| Minimum | -75 |
|---|---|
| Maximum | 2367 |
| Zeros | 10503 |
| Zeros (%) | 1.8% |
| Negative | 357897 |
| Negative (%) | 62.9% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | -75 |
|---|---|
| 5-th percentile | -26 |
| Q1 | -15 |
| median | -6 |
| Q3 | 7 |
| 95-th percentile | 72 |
| Maximum | 2367 |
| Range | 2442 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 55.367715 |
|---|---|
| Coefficient of variation (CV) | 10.264735 |
| Kurtosis | 187.3427 |
| Mean | 5.3939742 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 10.355198 |
| Sum | 3025410 |
| Variance | 3065.5839 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -10 | 16918 | 3.0% |
| -11 | 16858 | 3.0% |
| -12 | 16781 | 2.9% |
| -13 | 16599 | 2.9% |
| -9 | 16258 | 2.9% |
| -14 | 16170 | 2.8% |
| -8 | 16170 | 2.8% |
| -7 | 15512 | 2.7% |
| -15 | 15385 | 2.7% |
| -6 | 14833 | 2.6% |
| Other values (1138) | 399403 |
| Value | Count | Frequency (%) |
| -75 | 1 | < 0.1% |
| -74 | 2 | < 0.1% |
| -71 | 1 | < 0.1% |
| -70 | 1 | < 0.1% |
| -67 | 2 | < 0.1% |
| -66 | 3 | |
| -65 | 3 | |
| -64 | 2 | < 0.1% |
| -63 | 6 | |
| -62 | 3 |
| Value | Count | Frequency (%) |
| 2367 | 1 | |
| 2338 | 1 | |
| 2280 | 1 | |
| 2275 | 1 | |
| 2204 | 1 | |
| 2029 | 1 | |
| 1771 | 1 | |
| 1751 | 1 | |
| 1705 | 1 | |
| 1693 | 1 |
CANCELLED
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| 0.0 | |
|---|---|
| 1.0 | 7058 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1708014 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 562280 | |
| 1.0 | 7058 | 1.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 562280 | |
| 1.0 | 7058 | 1.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1131618 | |
| . | 569338 | |
| 1 | 7058 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1708014 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1131618 | |
| . | 569338 | |
| 1 | 7058 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1708014 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1131618 | |
| . | 569338 | |
| 1 | 7058 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1708014 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1131618 | |
| . | 569338 | |
| 1 | 7058 | 0.4% |
CANCELLATION_CODE
Categorical
MISSING
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 562280 |
| Missing (%) | 98.8% |
| Memory size | 4.3 MiB |
| C | |
|---|---|
| B | |
| A | |
| D | 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 7058 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| C | 2981 | 0.5% |
| B | 2612 | 0.5% |
| A | 1463 | 0.3% |
| D | 2 | < 0.1% |
| (Missing) | 562280 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| c | 2981 | |
| b | 2612 | |
| a | 1463 | |
| d | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 2981 | |
| B | 2612 | |
| A | 1463 | |
| D | 2 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7058 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 2981 | |
| B | 2612 | |
| A | 1463 | |
| D | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7058 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 2981 | |
| B | 2612 | |
| A | 1463 | |
| D | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7058 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 2981 | |
| B | 2612 | |
| A | 1463 | |
| D | 2 | < 0.1% |
DIVERTED
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| 0.0 | |
|---|---|
| 1.0 | 1393 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1708014 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 567945 | |
| 1.0 | 1393 | 0.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 567945 | |
| 1.0 | 1393 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1137283 | |
| . | 569338 | |
| 1 | 1393 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1708014 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1137283 | |
| . | 569338 | |
| 1 | 1393 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1708014 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1137283 | |
| . | 569338 | |
| 1 | 1393 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1708014 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1137283 | |
| . | 569338 | |
| 1 | 1393 | 0.1% |
AIR_TIME
Real number (ℝ)
MISSING
| Distinct | 596 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 8451 |
| Missing (%) | 1.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 112.89491 |
| Minimum | 8 |
|---|---|
| Maximum | 650 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 8 |
|---|---|
| 5-th percentile | 35 |
| Q1 | 62 |
| median | 95 |
| Q3 | 141 |
| 95-th percentile | 269.7 |
| Maximum | 650 |
| Range | 642 |
| Interquartile range (IQR) | 79 |
Descriptive statistics
| Standard deviation | 69.668573 |
|---|---|
| Coefficient of variation (CV) | 0.61710997 |
| Kurtosis | 2.1563815 |
| Mean | 112.89491 |
| Median Absolute Deviation (MAD) | 38 |
| Skewness | 1.3823404 |
| Sum | 63321286 |
| Variance | 4853.71 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 64 | 5007 | 0.9% |
| 61 | 4942 | 0.9% |
| 63 | 4918 | 0.9% |
| 62 | 4913 | 0.9% |
| 65 | 4903 | 0.9% |
| 60 | 4863 | 0.9% |
| 59 | 4765 | 0.8% |
| 66 | 4698 | 0.8% |
| 57 | 4560 | 0.8% |
| 53 | 4559 | 0.8% |
| Other values (586) | 512759 | |
| (Missing) | 8451 | 1.5% |
| Value | Count | Frequency (%) |
| 8 | 5 | < 0.1% |
| 9 | 20 | < 0.1% |
| 10 | 18 | < 0.1% |
| 11 | 3 | < 0.1% |
| 12 | 6 | < 0.1% |
| 14 | 16 | < 0.1% |
| 15 | 20 | < 0.1% |
| 16 | 105 | < 0.1% |
| 17 | 237 | |
| 18 | 330 |
| Value | Count | Frequency (%) |
| 650 | 1 | < 0.1% |
| 640 | 1 | < 0.1% |
| 636 | 2 | |
| 635 | 1 | < 0.1% |
| 629 | 1 | < 0.1% |
| 627 | 1 | < 0.1% |
| 626 | 1 | < 0.1% |
| 624 | 1 | < 0.1% |
| 623 | 1 | < 0.1% |
| 622 | 3 |
CARRIER_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 895 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 464639 |
| Missing (%) | 81.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.57522 |
| Minimum | 0 |
|---|---|
| Maximum | 2360 |
| Zeros | 48222 |
| Zeros (%) | 8.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3 |
| Q3 | 23 |
| 95-th percentile | 106 |
| Maximum | 2360 |
| Range | 2360 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 77.653248 |
|---|---|
| Coefficient of variation (CV) | 3.036269 |
| Kurtosis | 123.31017 |
| Mean | 25.57522 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 9.2562768 |
| Sum | 2677700 |
| Variance | 6030.027 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 48222 | 8.5% |
| 1 | 1826 | 0.3% |
| 2 | 1710 | 0.3% |
| 15 | 1704 | 0.3% |
| 6 | 1669 | 0.3% |
| 3 | 1651 | 0.3% |
| 4 | 1636 | 0.3% |
| 7 | 1530 | 0.3% |
| 16 | 1489 | 0.3% |
| 5 | 1466 | 0.3% |
| Other values (885) | 41796 | 7.3% |
| (Missing) | 464639 |
| Value | Count | Frequency (%) |
| 0 | 48222 | |
| 1 | 1826 | 0.3% |
| 2 | 1710 | 0.3% |
| 3 | 1651 | 0.3% |
| 4 | 1636 | 0.3% |
| 5 | 1466 | 0.3% |
| 6 | 1669 | 0.3% |
| 7 | 1530 | 0.3% |
| 8 | 1412 | 0.2% |
| 9 | 1344 | 0.2% |
| Value | Count | Frequency (%) |
| 2360 | 1 | |
| 2280 | 1 | |
| 2275 | 1 | |
| 1691 | 1 | |
| 1677 | 1 | |
| 1638 | 1 | |
| 1591 | 1 | |
| 1550 | 1 | |
| 1534 | 1 | |
| 1501 | 1 |
WEATHER_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 441 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 464639 |
| Missing (%) | 81.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.5982388 |
| Minimum | 0 |
|---|---|
| Maximum | 1209 |
| Zeros | 99278 |
| Zeros (%) | 17.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 3 |
| Maximum | 1209 |
| Range | 1209 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 28.964834 |
|---|---|
| Coefficient of variation (CV) | 8.0497253 |
| Kurtosis | 461.58311 |
| Mean | 3.5982388 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 17.952111 |
| Sum | 376732 |
| Variance | 838.96159 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 99278 | 17.4% |
| 15 | 118 | < 0.1% |
| 16 | 118 | < 0.1% |
| 19 | 104 | < 0.1% |
| 8 | 102 | < 0.1% |
| 18 | 100 | < 0.1% |
| 23 | 90 | < 0.1% |
| 17 | 89 | < 0.1% |
| 11 | 86 | < 0.1% |
| 20 | 83 | < 0.1% |
| Other values (431) | 4531 | 0.8% |
| (Missing) | 464639 |
| Value | Count | Frequency (%) |
| 0 | 99278 | |
| 1 | 67 | < 0.1% |
| 2 | 79 | < 0.1% |
| 3 | 80 | < 0.1% |
| 4 | 73 | < 0.1% |
| 5 | 62 | < 0.1% |
| 6 | 82 | < 0.1% |
| 7 | 71 | < 0.1% |
| 8 | 102 | < 0.1% |
| 9 | 74 | < 0.1% |
| Value | Count | Frequency (%) |
| 1209 | 1 | |
| 1125 | 1 | |
| 1112 | 1 | |
| 1109 | 1 | |
| 1105 | 1 | |
| 1079 | 1 | |
| 1056 | 1 | |
| 1039 | 1 | |
| 1020 | 1 | |
| 1017 | 1 |
NAS_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 452 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 464639 |
| Missing (%) | 81.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.98638 |
| Minimum | 0 |
|---|---|
| Maximum | 1382 |
| Zeros | 54825 |
| Zeros (%) | 9.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 17 |
| 95-th percentile | 61 |
| Maximum | 1382 |
| Range | 1382 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 37.400842 |
|---|---|
| Coefficient of variation (CV) | 2.6740902 |
| Kurtosis | 225.79833 |
| Mean | 13.98638 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.108494 |
| Sum | 1464360 |
| Variance | 1398.823 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 54825 | 9.6% |
| 1 | 2609 | 0.5% |
| 2 | 1924 | 0.3% |
| 3 | 1853 | 0.3% |
| 15 | 1819 | 0.3% |
| 16 | 1741 | 0.3% |
| 4 | 1736 | 0.3% |
| 5 | 1560 | 0.3% |
| 17 | 1559 | 0.3% |
| 6 | 1506 | 0.3% |
| Other values (442) | 33567 | 5.9% |
| (Missing) | 464639 |
| Value | Count | Frequency (%) |
| 0 | 54825 | |
| 1 | 2609 | 0.5% |
| 2 | 1924 | 0.3% |
| 3 | 1853 | 0.3% |
| 4 | 1736 | 0.3% |
| 5 | 1560 | 0.3% |
| 6 | 1506 | 0.3% |
| 7 | 1351 | 0.2% |
| 8 | 1323 | 0.2% |
| 9 | 1258 | 0.2% |
| Value | Count | Frequency (%) |
| 1382 | 1 | |
| 1246 | 1 | |
| 1138 | 1 | |
| 1135 | 1 | |
| 1105 | 1 | |
| 1104 | 1 | |
| 1092 | 1 | |
| 1089 | 1 | |
| 1055 | 1 | |
| 1022 | 1 |
SECURITY_DELAY
Real number (ℝ)
MISSING SKEWED ZEROS
| Distinct | 87 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 464639 |
| Missing (%) | 81.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.13765174 |
| Minimum | 0 |
|---|---|
| Maximum | 600 |
| Zeros | 104179 |
| Zeros (%) | 18.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 600 |
| Range | 600 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.4992708 |
|---|---|
| Coefficient of variation (CV) | 25.421188 |
| Kurtosis | 12346.781 |
| Mean | 0.13765174 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 89.294279 |
| Sum | 14412 |
| Variance | 12.244896 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 104179 | 18.3% |
| 10 | 20 | < 0.1% |
| 15 | 19 | < 0.1% |
| 5 | 18 | < 0.1% |
| 21 | 16 | < 0.1% |
| 16 | 16 | < 0.1% |
| 19 | 16 | < 0.1% |
| 9 | 15 | < 0.1% |
| 11 | 15 | < 0.1% |
| 13 | 15 | < 0.1% |
| Other values (77) | 370 | 0.1% |
| (Missing) | 464639 |
| Value | Count | Frequency (%) |
| 0 | 104179 | |
| 1 | 7 | < 0.1% |
| 2 | 8 | < 0.1% |
| 3 | 13 | < 0.1% |
| 4 | 14 | < 0.1% |
| 5 | 18 | < 0.1% |
| 6 | 7 | < 0.1% |
| 7 | 13 | < 0.1% |
| 8 | 8 | < 0.1% |
| 9 | 15 | < 0.1% |
| Value | Count | Frequency (%) |
| 600 | 1 | |
| 449 | 1 | |
| 373 | 1 | |
| 191 | 1 | |
| 151 | 1 | |
| 142 | 1 | |
| 129 | 1 | |
| 115 | 1 | |
| 109 | 1 | |
| 108 | 1 |
LATE_AIRCRAFT_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 652 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 464639 |
| Missing (%) | 81.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.878652 |
| Minimum | 0 |
|---|---|
| Maximum | 2329 |
| Zeros | 52932 |
| Zeros (%) | 9.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 30 |
| 95-th percentile | 120 |
| Maximum | 2329 |
| Range | 2329 |
| Interquartile range (IQR) | 30 |
Descriptive statistics
| Standard deviation | 62.205062 |
|---|---|
| Coefficient of variation (CV) | 2.3142925 |
| Kurtosis | 127.87143 |
| Mean | 26.878652 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.9789338 |
| Sum | 2814168 |
| Variance | 3869.4697 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 52932 | 9.3% |
| 15 | 1307 | 0.2% |
| 16 | 1218 | 0.2% |
| 17 | 1188 | 0.2% |
| 18 | 1108 | 0.2% |
| 20 | 1039 | 0.2% |
| 19 | 1019 | 0.2% |
| 21 | 938 | 0.2% |
| 22 | 914 | 0.2% |
| 12 | 896 | 0.2% |
| Other values (642) | 42140 | 7.4% |
| (Missing) | 464639 |
| Value | Count | Frequency (%) |
| 0 | 52932 | |
| 1 | 679 | 0.1% |
| 2 | 716 | 0.1% |
| 3 | 713 | 0.1% |
| 4 | 710 | 0.1% |
| 5 | 734 | 0.1% |
| 6 | 778 | 0.1% |
| 7 | 795 | 0.1% |
| 8 | 741 | 0.1% |
| 9 | 757 | 0.1% |
| Value | Count | Frequency (%) |
| 2329 | 1 | |
| 2204 | 1 | |
| 1761 | 1 | |
| 1733 | 1 | |
| 1682 | 1 | |
| 1522 | 1 | |
| 1498 | 1 | |
| 1442 | 1 | |
| 1432 | 1 | |
| 1397 | 1 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 9/4/2023 12:00:00 AM | 9E | 4871 | 10693 | BNA | Nashville, TN | Tennessee | 54 | 12953 | LGA | New York, NY | New York | 22 | 1951 | 1956.0 | 5.0 | 22.0 | 5.0 | 2316 | 2317.0 | 1.0 | 0.0 | NaN | 0.0 | 114.0 | NaN | NaN | NaN | NaN | NaN |
| 1 | 1 | 9/4/2023 12:00:00 AM | 9E | 4871 | 12953 | LGA | New York, NY | New York | 22 | 10693 | BNA | Nashville, TN | Tennessee | 54 | 1655 | 1759.0 | 64.0 | 31.0 | 12.0 | 1836 | 1926.0 | 50.0 | 0.0 | NaN | 0.0 | 104.0 | 9.0 | 0.0 | 0.0 | 0.0 | 41.0 |
| 2 | 1 | 9/4/2023 12:00:00 AM | 9E | 4900 | 14524 | RIC | Richmond, VA | Virginia | 38 | 13487 | MSP | Minneapolis, MN | Minnesota | 63 | 619 | 614.0 | -5.0 | 22.0 | 10.0 | 819 | 807.0 | -12.0 | 0.0 | NaN | 0.0 | 141.0 | NaN | NaN | NaN | NaN | NaN |
| 3 | 1 | 9/4/2023 12:00:00 AM | 9E | 4901 | 11057 | CLT | Charlotte, NC | North Carolina | 36 | 12478 | JFK | New York, NY | New York | 22 | 1955 | 1943.0 | -12.0 | 15.0 | 13.0 | 2210 | 2143.0 | -27.0 | 0.0 | NaN | 0.0 | 92.0 | NaN | NaN | NaN | NaN | NaN |
| 4 | 1 | 9/4/2023 12:00:00 AM | 9E | 4901 | 12478 | JFK | New York, NY | New York | 22 | 11057 | CLT | Charlotte, NC | North Carolina | 36 | 1629 | 1628.0 | -1.0 | 49.0 | 11.0 | 1907 | 1845.0 | -22.0 | 0.0 | NaN | 0.0 | 77.0 | NaN | NaN | NaN | NaN | NaN |
| 5 | 1 | 9/4/2023 12:00:00 AM | 9E | 4902 | 15096 | SYR | Syracuse, NY | New York | 22 | 11433 | DTW | Detroit, MI | Michigan | 43 | 615 | 614.0 | -1.0 | 12.0 | 8.0 | 746 | 733.0 | -13.0 | 0.0 | NaN | 0.0 | 59.0 | NaN | NaN | NaN | NaN | NaN |
| 6 | 1 | 9/4/2023 12:00:00 AM | 9E | 4903 | 10599 | BHM | Birmingham, AL | Alabama | 51 | 12953 | LGA | New York, NY | New York | 22 | 1236 | 1232.0 | -4.0 | 13.0 | 6.0 | 1604 | 1558.0 | -6.0 | 0.0 | NaN | 0.0 | 127.0 | NaN | NaN | NaN | NaN | NaN |
| 7 | 1 | 9/4/2023 12:00:00 AM | 9E | 4903 | 12953 | LGA | New York, NY | New York | 22 | 10599 | BHM | Birmingham, AL | Alabama | 51 | 841 | 836.0 | -5.0 | 22.0 | 3.0 | 1022 | 959.0 | -23.0 | 0.0 | NaN | 0.0 | 118.0 | NaN | NaN | NaN | NaN | NaN |
| 8 | 1 | 9/4/2023 12:00:00 AM | 9E | 4904 | 10581 | BGR | Bangor, ME | Maine | 12 | 12953 | LGA | New York, NY | New York | 22 | 1221 | 1216.0 | -5.0 | 10.0 | 5.0 | 1404 | 1337.0 | -27.0 | 0.0 | NaN | 0.0 | 66.0 | NaN | NaN | NaN | NaN | NaN |
| 9 | 1 | 9/4/2023 12:00:00 AM | 9E | 4904 | 12953 | LGA | New York, NY | New York | 22 | 10581 | BGR | Bangor, ME | Maine | 12 | 945 | 931.0 | -14.0 | 28.0 | 3.0 | 1134 | 1102.0 | -32.0 | 0.0 | NaN | 0.0 | 60.0 | NaN | NaN | NaN | NaN | NaN |
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 569328 | 7 | 9/24/2023 12:00:00 AM | YX | 5820 | 11057 | CLT | Charlotte, NC | North Carolina | 36 | 12478 | JFK | New York, NY | New York | 22 | 630 | 626.0 | -4.0 | 18.0 | 17.0 | 838 | 815.0 | -23.0 | 0.0 | NaN | 0.0 | 74.0 | NaN | NaN | NaN | NaN | NaN |
| 569329 | 7 | 9/24/2023 12:00:00 AM | YX | 5823 | 11057 | CLT | Charlotte, NC | North Carolina | 36 | 12953 | LGA | New York, NY | New York | 22 | 1927 | 1926.0 | -1.0 | 27.0 | 13.0 | 2129 | 2123.0 | -6.0 | 0.0 | NaN | 0.0 | 77.0 | NaN | NaN | NaN | NaN | NaN |
| 569330 | 7 | 9/24/2023 12:00:00 AM | YX | 5824 | 12478 | JFK | New York, NY | New York | 22 | 11057 | CLT | Charlotte, NC | North Carolina | 36 | 2000 | 2103.0 | 63.0 | 38.0 | 8.0 | 2222 | 2308.0 | 46.0 | 0.0 | NaN | 0.0 | 79.0 | 0.0 | 0.0 | 0.0 | 0.0 | 46.0 |
| 569331 | 7 | 9/24/2023 12:00:00 AM | YX | 5826 | 11433 | DTW | Detroit, MI | Michigan | 43 | 14122 | PIT | Pittsburgh, PA | Pennsylvania | 23 | 2120 | 2124.0 | 4.0 | 12.0 | 5.0 | 2222 | 2215.0 | -7.0 | 0.0 | NaN | 0.0 | 34.0 | NaN | NaN | NaN | NaN | NaN |
| 569332 | 7 | 9/24/2023 12:00:00 AM | YX | 5828 | 12339 | IND | Indianapolis, IN | Indiana | 42 | 12953 | LGA | New York, NY | New York | 22 | 1445 | 1525.0 | 40.0 | 19.0 | 16.0 | 1654 | 1740.0 | 46.0 | 0.0 | NaN | 0.0 | 100.0 | 0.0 | 0.0 | 46.0 | 0.0 | 0.0 |
| 569333 | 7 | 9/24/2023 12:00:00 AM | YX | 5828 | 12953 | LGA | New York, NY | New York | 22 | 12339 | IND | Indianapolis, IN | Indiana | 42 | 1130 | 1121.0 | -9.0 | 31.0 | 8.0 | 1352 | 1334.0 | -18.0 | 0.0 | NaN | 0.0 | 94.0 | NaN | NaN | NaN | NaN | NaN |
| 569334 | 7 | 9/24/2023 12:00:00 AM | YX | 5834 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 11278 | DCA | Washington, DC | Virginia | 38 | 1515 | 1538.0 | 23.0 | 51.0 | 44.0 | 1708 | 1833.0 | 85.0 | 0.0 | NaN | 0.0 | 80.0 | 0.0 | 0.0 | 62.0 | 0.0 | 23.0 |
| 569335 | 7 | 9/24/2023 12:00:00 AM | YX | 5834 | 11278 | DCA | Washington, DC | Virginia | 38 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1830 | 1948.0 | 78.0 | 46.0 | 23.0 | 2018 | 2158.0 | 100.0 | 0.0 | NaN | 0.0 | 61.0 | 0.0 | 0.0 | 54.0 | 0.0 | 46.0 |
| 569336 | 7 | 9/24/2023 12:00:00 AM | YX | 5836 | 14524 | RIC | Richmond, VA | Virginia | 38 | 12953 | LGA | New York, NY | New York | 22 | 900 | 854.0 | -6.0 | 15.0 | 6.0 | 1029 | 1000.0 | -29.0 | 0.0 | NaN | 0.0 | 45.0 | NaN | NaN | NaN | NaN | NaN |
| 569337 | 7 | 9/24/2023 12:00:00 AM | YX | 5839 | 12953 | LGA | New York, NY | New York | 22 | 13485 | MSN | Madison, WI | Wisconsin | 45 | 2050 | 2129.0 | 39.0 | 19.0 | 5.0 | 2227 | 2245.0 | 18.0 | 0.0 | NaN | 0.0 | 112.0 | 0.0 | 0.0 | 0.0 | 0.0 | 18.0 |